package com.sto.stoapp.db.constant;

/**
 * 面单
 * 
 * @author cjb
 * 
 */
public interface StoBillcodeConstant extends StoBaseConstant {

	/**
	 * 发放时间
	 */
	public static final String EXTEND_DATE = "extenddate";
	/**
	 * 名称
	 */
	public static final String SITE_NAME = "sitename";
	/**
	 * 起
	 */
	public static final String BILLCODE_BEGIN = "billcodebegin";
	/**
	 * 终
	 */
	public static final String BILLCODE_END = "billcodeend";
	/**
	 * 发放数量
	 */
	public static final String RELEASE_QUANTITY = "releasequantity";
	/**
	 * 面单表名
	 */
	public static final String BILLCODE_TABLE = "billcode_table";
	/**
	 * 面单数据库表
	 */
	public static final String CREATE_BILLCODE_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ BILLCODE_TABLE
			+ "("
			+ EXTEND_DATE
			+ " char(30) "
			+ ","
			+ SITE_NAME
			+ " char(30)"
			+ ","
			+ BILLCODE_BEGIN
			+ " char(30)"
			+ ","
			+ BILLCODE_END
			+ " char(30) "
			+ ","
			+ RELEASE_QUANTITY
			+ " char(30) "
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE
			+ " char(50)"
			+ ","
			+ " primary key "
			+ "("
			+ SITE_NAME
			+ ","
			+ BILLCODE_BEGIN
			+ "," + BILLCODE_END + ")" + ")";

	/**
	 * 删除问题件数据库表
	 */
	public static final String DROP_BILLCODE_TABLE = "drop table if exists "
			+ BILLCODE_TABLE;
}
